Contents

Analysis

Looking for insights into the Vaccination Uptake by analysis of New Zealand Ministry of Health Covid 19 Vaccination data

This analysis is focused on Northland, NZ

We will explore the rate of change of the unvaccinated by Age, Sex and Ethnicity

This study aims to be impartial and does not warrant the source of the data or the accuracy of the data reports or graphs generated.

Full Disclosure

The author of this study has no medical training and is not affiliated to any medical or any other group handling Covid19 responses.

It is strongly advised that anyone unsure about getting vaccinated or is looking for further information, consult with a registered medical person or seek validated official communications from appropriate authorities.

The author is vaccinated with the Phizer Covid19 Vaccine (COMIRNATY) with active ingredient BNT162b2

Plots of current vaccination ratios

from IPython.core.display import display, HTML
from plotly.offline import init_notebook_mode, plot
init_notebook_mode(connected=True)

import modules
import modules.data_prep as dp
import modules.data_viz1 as dv

data = dp.MOH_data()
data.prep_step1_pull_data()
data.prep_step_2_read_all_uptake_data()
data.prep_step_3_generate_report_data()

Accessing github with Github Personal Access Token: ghp_Z.............DwEJW

Repo at ../data_moh_nz successfully loaded.

The last data committed by the MHO is: '2021-11-04 08:57:19+13:00 62755abf LOI updated as at 8am 4.11.2021'

Current week is: '21W44'

The eligible population is: 161223

The current unvaccinated but eligible population is: 33475.0

Total New, first time vaccinations: 2447

Percentages

Partial and fully vaccinated as % of eligible population: '79.67%'

Fully Vaccinated as % eligible population : '65.46%'

Newly Vaccinated as % of unvaccinated but eligible population: '6.81%' (unvaccinated population at beginning of week)

Graphs

plot(dv.plot2(data.df_all_weeks_no_gender_age_category), filename = 'figure2.html')
display(HTML('figure2.html'))

plot(dv.plot3(data.df_all_weeks_no_gender_age_category), filename = 'figure3.html')
display(HTML('figure3.html'))

df = data.df_all_weeks_no_gender_age_category.query((
    '["European or Other", "Maori"] in `Ethnic group`'
    # ' and `Age Category` == "12-19"'
    # ' and ["12-19","20-39"] in `Age Category`'
    )
).sort_values(["Age Category", "Ethnic group"])


plot(dv.plot_overall_vaccination_status(df),filename = 'figure4.html')
display(HTML('figure4.html'))

The following pltos indicate the amount of first doses received each week. The 2 main large populations are looked at: Maori and European

# import plotly.io as pio
import plotly.express as px
# import plotly.offline as py

ethnic_group="Maori, European or Other"
fig = px.bar(data.df_all_weeks_no_gender.query(f'{ethnic_group.split(", ")} in `Ethnic group`'), 
    x="Week ending", 
    y="First dose administered Changed", 
    title=f"{ethnic_group} -  First dose received",
    facet_col="Ethnic group", 
    # facet_col="Gender",
    color='Age Category',
    text='First dose administered Changed',
    hover_data=[
        "Ethnic group",
        "Age Category",
        "Population unvaccinated at week start",
        "Population unvaccinated at week end",
        "Population",
        "First dose administered_prior",
        "First dose administered Changed",
        "First dose administered Changed as Percent of unvaccinated Population",
    ],)
plot(fig,filename = 'figure5.html')
display(HTML('figure5.html'))

ethnic_group="European or Other"
fig = px.bar(data.df_all_weeks_no_gender.loc[data.df_all_weeks_no_gender['Ethnic group']==ethnic_group], 
    x="Week ending", 
    y="First dose administered Changed", 
    title=f"{ethnic_group} -  First dose received",
    color='Age Category',
    # facet_col="Gender",
    hover_data=[
        "Ethnic group",
        "Age Category",
        "Population unvaccinated at week start",
        "Population unvaccinated at week end",
        "Population",
        "First dose administered_prior",
        "First dose administered Changed",
        "First dose administered Changed as Percent of unvaccinated Population",
    ],)
plot(fig,filename = 'figure6.html')
display(HTML('figure6.html'))

ethnic_group="Maori"
fig = px.bar(data.df_all_weeks_no_gender.loc[data.df_all_weeks_no_gender['Ethnic group']==ethnic_group], 
    x="Week ending", 
    y="First dose administered Changed", 
    title=f"{ethnic_group} -  First dose received",
    color='Age Category',
    # facet_col="Gender",
    hover_data=[
        "Ethnic group",
        "Age Category",
        "Population unvaccinated at week start",
        "Population unvaccinated at week end",
        "Population",
        "First dose administered_prior",
        "First dose administered Changed",
        "First dose administered Changed as Percent of unvaccinated Population",
    ],)
plot(fig,filename = 'figure7.html')
display(HTML('figure7.html'))

References

Data source: Ministry of Health, New Zealand COVID-19 Data - https://github.com/minhealthnz/nz-covid-data

Further information

Northland DHB, COVID-19 Northland Hub: https://www.northlanddhb.org.nz/home/covid-19/covid-19-northland-hub/